Retrieve the last preceding value matching a criteria in Excel using INDEX, MATCH, and LARGE to handle time-series data without VBA.